Database

In this group, you can configure the database connection for the Orchestra runtime database. Ensure that only one of the provided groups is enabled (enabled="true").

Runtime Database Configuration

Parameter	Description
enabled	Activates or deactivates the given database connection. Only one connection can be set to true.
runtime.db.typ	Defines the type of the configured database (e.g., ORACLE, MSSQL, MYSQL, Derby, PostgreSQL).
runtime.url	JDBC URL used as the database connection string. For MySQL since version 4.8: must include serverTimezone=UTC due to DST handling issues. For PostgreSQL servers, if Orchestra is located in a schema different from the default schema "public" the connection string will have to include currentSchema=&quot;<schema name>&quot; to specify the custom schema to be used.
runtime.user	Database user, encrypted as a two-way password.
runtime.pwd	Database password, encrypted as a two-way password.
runtime.connect.property	Sets connection properties such as timeout (mainly for ORACLE). - MS-SQL: prevents blocking reads by setting socket timeout. - Default Query Timeout: aborts statements exceeding specified seconds.
runtime.limit	Maximum number of open connections (only used with MySQL).
runtime.initWaitTime	Initial wait time before attempting to connect to the database, in seconds.
runtime.startUpTime	Time span (in seconds) during which attempts to establish a database connection are made.
auto.install	Enables automatic database migration at startup (true = Orchestra sets up/updates runtime and archive DB automatically).
script.location	Path to database migration scripts. If left blank, Orchestra uses migration scripts from its libraries.

Archive Database Configuration

Parameter	Description
archive.db.typ	Defines the type of the configured archive database.
archive.url	JDBC URL used as the database connection string for the archive database.
archive.user	Archive database user, encrypted as a two-way password.
archive.pwd	Archive database password, encrypted as a two-way password.